﻿CREATE TABLE [dbo].[RouteDepartureSchedule] (
    [id]             INT            IDENTITY (1, 1) NOT NULL,
    [id_routetable]  INT            NOT NULL,
    [id_route]       INT            NOT NULL,
    [name_busstop]   NVARCHAR (MAX) NOT NULL,
    [time_arrive]    NVARCHAR (MAX) NOT NULL,
    [time_departure] NVARCHAR (MAX) NOT NULL,
    PRIMARY KEY CLUSTERED ([id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

